Mik Nostrebor
Minmatar
ORKS
   |
Posted - 2006.12.07 03:45:00 -
[2]
Edited by: Mik Nostrebor on 07/12/2006 03:53:42
Edited by: Mik Nostrebor on 07/12/2006 03:51:07
I am working on getting the item tables done. I can post the SQL CREATE statements for them. The typing will be a bit broad (ie int instead of boolean and float for non-ID fields etc).
I am to impatient to wait for someone else to do it.
Here are the Categories, Groups and Types tables for MSSQL. NOTE: replace ",true," with ",1," in the types table for this to work.:
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[invCategories]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[invCategories]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[invGroups]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[invGroups]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[invTypes]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[invTypes]
GO
CREATE TABLE [dbo].[invCategories] (
[CategoryID] [int] NOT NULL ,
[CategoryName] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[description] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[graphicID] [int] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
CREATE TABLE [dbo].[invGroups] (
[groupID] [int] NULL ,
[categoryID] [int] NULL ,
[groupName] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[description] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[graphicID] [int] NULL ,
[useBasePrice] [float] NULL ,
[allowManufacture] [int] NULL ,
[allowRecyler] [int] NULL ,
[anchored] [int] NULL ,
[anchorable] [int] NULL ,
[*****bleNonSingleton] [int] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
CREATE TABLE [dbo].[invTypes] (
[typeID] [int] NOT NULL ,
[groupID] [int] NULL ,
[typeName] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[description] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[graphicID] [int] NULL ,
[radius] [float] NULL ,
[mass] [float] NULL ,
[volume] [float] NULL ,
[capacity] [float] NULL ,
[portionSize] [float] NULL ,
[raceID] [int] NULL ,
[basePrice] [float] NULL ,
[published] [int] NULL ,
[marketGroupID] [int] NULL ,
[chanceOfDuplicating] [int] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO |